# noinspection SqlNoDataSourceInspectionForFile

/*
 Navicat Premium Data Transfer

 Source Server         : 本地数据库
 Source Server Type    : MySQL
 Source Server Version : 50719
 Source Host           : localhost
 Source Database       : resondemo

 Target Server Type    : MySQL
 Target Server Version : 50719
 File Encoding         : utf-8

 Date: 03/15/2018 11:53:18 AM
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `user_dbdest`
-- ----------------------------
DROP TABLE IF EXISTS `user_dbdest`;
CREATE TABLE `user_dbdest` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `dest_user_name` varchar(10) DEFAULT NULL,
  `dest_phone_num` varchar(13) DEFAULT NULL COMMENT '手机号',
  `dest_err_status` varchar(2) DEFAULT NULL COMMENT '勾兑不成功的，表1存在表2不存在的，写1，表1不存在，表2存在的，写2',
  `dest_car_no` varchar(10) DEFAULT NULL COMMENT '当时交易凭证',
  `dest_car_time` varchar(20) DEFAULT NULL COMMENT '勾兑差异时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `user_src1`
-- ----------------------------
DROP TABLE IF EXISTS `user_src1`;
CREATE TABLE `user_src1` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_name` varchar(10) DEFAULT NULL,
  `phone_num` varchar(13) DEFAULT NULL COMMENT '手机号',
  `u_status` varchar(2) DEFAULT NULL COMMENT '勾兑成功后，回写数据库，成功，回写为2',
  `car_no` varchar(10) DEFAULT NULL COMMENT '当时交易凭证',
  `last_update` varchar(15) DEFAULT NULL COMMENT '最后跟新日期',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `user_src1`
-- ----------------------------
BEGIN;
INSERT INTO `user_src1` VALUES ('1', '张三丰', '18233583070', '00', '1234567', '2018-03-10'), ('2', '马大哈', '13800138000', '00', '1234567', '2018-03-10'), ('3', '大张伟', '18888888888', '00', '12345678', '2018-03-10'), ('4', '老王', '19999999999', '00', '1212434', '2017-12-12');
COMMIT;

-- ----------------------------
--  Table structure for `user_src2`
-- ----------------------------
DROP TABLE IF EXISTS `user_src2`;
CREATE TABLE `user_src2` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `acc_user_name` varchar(10) DEFAULT NULL,
  `acc_phone_num` varchar(13) DEFAULT NULL COMMENT '手机号',
  `acc_u_status` varchar(2) DEFAULT NULL COMMENT '勾兑成功后，回写数据库，成功，回写为2',
  `acc_car_no` varchar(10) DEFAULT NULL COMMENT '当时交易凭证',
  `acc_last_update` varchar(11) DEFAULT NULL COMMENT '最后跟新日期',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `user_src2`
-- ----------------------------
BEGIN;
INSERT INTO `user_src2` VALUES ('1', '张三丰', '18233583070', '00', '1234567', '2018-03-10'), ('2', '马大哈', '13800138000', '00', '12347534', '2018-03-10'), ('3', '大张伟', '18888888888', '00', '12345678', '2018-03-10'), ('4', '葛优', '13013013000', '00', '12345678', '2017-12-12');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
